SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001372s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401570 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401570 [ RunTime:0.001974s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (977868,1015370,821436,8651,465000,511206,572393,894329,676735,311976,88535,650595,326550,641728,327182,363493,875770,703823,503224,321265,492032,843922,1041379,292090,267741,163748,535009,180996,139160,234686,565865,361030,432986,879321,312592,370091,890435,666655,37048,560573,717360,353255,918319,765577,678280,496736,302938,678883,915179,437653,49193,47104,361883,283716,81168,663193,963922,82478,341477,172527) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401570 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000543s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401570 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000813s ]