SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002776s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310612 LIMIT 1 [ RunTime:0.000573s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310612 [ RunTime:0.005113s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (777011,352961,910086,865320,292282,295484,378411,706131,1008889,427436,36257,575383,558035,991949,129583,349220,306145,594191,769902,332381,134868,744074,905195,560627,135643,602294,507998,387407,829613,677053,888004,549061,320470,643966,808003,507541,703602,447843,800100,366573,932040,735244,78926,699687,1045806,845069,630918,1003181,811791,473477,529871,135716,329673,940214,313551,256645,95172,1043354,6435,857072) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310612 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000475s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310612 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]