SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001488s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310015 LIMIT 1 [ RunTime:0.000490s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310015 [ RunTime:0.001440s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (680584,549543,1021702,674871,688787,446817,960495,133770,205872,385015,804091,593039,116525,147806,374394,723266,167553,464969,552517,397069,130306,631924,142226,629693,428925,380104,111257,886016,923287,755143,427650,221080,688236,190698,163200,14140,284183,475388,129728,250951,739921,820191,943266,979970,716036,1042945,266662,800714,1028062,133965,325731,670535,735009,82651,216534,409374,227934,860189,985389,874662) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310015 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310015 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]