SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023126 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023126 [ RunTime:0.003411s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (163841,480364,920744,398321,742907,692360,831538,205209,153692,394249,445076,516483,865258,923800,535885,169199,511884,64370,668160,375500,501309,319844,113978,946106,473107,117243,546676,62523,221555,648544,453350,498127,586600,90370,984111,1003468,648567,397695,1016472,622730,479953,770688,710419,478697,394506,194192,936467,671676,42303,734681,876034,3361,62946,1012022,683983,329163,811197,142076,709185,718937) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023126 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023126 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]