SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509616 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509616 [ RunTime:0.001770s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (199071,98672,437986,693174,685463,256688,619975,1037226,622106,476937,179607,137646,302274,592453,745295,37931,830079,821700,736284,469517,787077,668278,570280,896657,903923,942565,163178,848158,427393,735780,323617,816819,923590,944020,188570,696643,579113,370266,206028,913685,955708,36430,310091,121809,728115,437104,400032,16580,251527,286855,886596,106952,60668,618212,588055,695082,580646,734884,979503,55014) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509616 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000573s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509616 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]