SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 398368 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 398368 [ RunTime:0.001611s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (402991,544107,628658,677889,690315,282461,325081,461865,1030285,517093,214551,4298,561964,1029131,16889,295065,52165,863127,330892,376023,687009,858166,228815,738576,935731,207155,157009,249987,172461,912617,284307,65076,109464,472605,943537,826250,645208,429559,42877,555183,368863,207914,987220,612591,757973,720759,1019926,588452,188753,64063,281532,131129,132076,483393,174754,927444,877368,540983,315394,398867) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000971s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 398368 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 398368 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000463s ]