SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 130043 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 130043 [ RunTime:0.002627s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1027099,137687,456050,391697,985473,470492,281540,498670,3358,31600,446400,855101,16889,568722,66744,182193,800079,227384,891550,178364,271369,150848,344839,326646,249936,685936,250833,268089,476183,849212,336059,955727,903140,487951,182114,977185,888383,389629,775745,880319,212336,766775,835215,1041830,430024,788479,1038697,863854,3242,458646,531419,144776,530383,551402,4233,816797,453965,40401,613014,625030) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 130043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000481s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 130043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]