SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54138 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54138 [ RunTime:0.001581s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (969517,1007732,813255,138956,839168,400417,34410,100889,997226,587654,448378,339226,10321,617537,53773,373031,974826,366322,2893,535560,945080,555555,66664,643503,628000,151783,31703,883312,873472,841993,964830,13193,836578,268640,220684,695534,324082,861620,59491,131639,892401,487547,616542,540934,722116,222229,39241,11384,537617,371410,774069,82093,271482,213363,580485,561213,920512,583162,559041,476768) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54138 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000502s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54138 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000810s ]