SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 408499 LIMIT 1 [ RunTime:0.000747s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 408499 [ RunTime:0.001628s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (10107,142467,275515,941755,2306,959067,831188,864036,818565,798896,818479,1040793,160808,351280,675120,514518,272999,1021994,607314,15658,197234,472466,493501,744236,987397,581548,308958,629683,478974,296964,174629,814256,783229,632191,23032,768514,1044256,685652,339205,270832,187763,696845,365869,489330,993779,784959,332596,7034,643631,1023928,338543,434319,927648,1003407,668525,527663,816995,170528,600502,342998) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002812s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 408499 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000660s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 408499 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002678s ]