SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002662s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532122 LIMIT 1 [ RunTime:0.001356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532122 [ RunTime:0.002096s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (548821,660404,565716,1006595,276058,283327,391332,845555,773291,40875,766988,934817,617593,976021,785283,282017,495833,1047305,139540,627430,894340,661184,808676,399681,669489,1015658,492644,276328,289132,875780,276921,409415,328784,303838,286900,144280,241531,563645,372468,626596,458141,15284,515959,933158,433248,786315,180636,420001,127957,295517,29763,167399,387019,191716,29445,309177,949697,282555,901915,822061) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532122 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532122 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000410s ]