SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414645 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414645 [ RunTime:0.002153s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (852359,78557,405872,1043781,832046,15340,486812,739101,352003,373914,782443,564254,14531,1016893,200402,134005,22473,787076,67173,906145,373378,47277,389795,381320,939127,615116,458023,641913,914052,58899,594313,405778,721648,728607,286904,614,496233,915105,161501,321865,503944,1017872,874302,950426,597204,838452,131924,615032,985143,233642,8002,880619,719893,941252,808868,920360,531554,383069,181127,448299) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414645 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414645 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]