SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 559018 LIMIT 1 [ RunTime:0.000532s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 559018 [ RunTime:0.002433s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (306292,840344,640786,688602,906303,625826,542385,793572,674112,202827,137024,495517,413928,497572,713560,739588,68144,244614,153824,695904,486052,85342,336187,235169,990463,146777,461091,521793,393911,9666,18311,111553,613327,711717,187057,585327,139089,167997,92491,259185,674835,983265,363431,102542,802456,830719,140840,25642,1020263,916939,312625,1005405,59636,813737,201901,1017671,621662,237952,14090,981744) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 559018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 559018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]