SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540628 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540628 [ RunTime:0.002159s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (325061,897230,42006,328077,900506,632633,418089,161394,442838,664772,585603,78772,942306,193683,287403,683701,986581,222411,350891,1016009,286233,928506,705912,745604,409785,980914,561583,400610,941697,525984,623023,835743,13991,91242,1034234,378620,754572,264038,364367,121953,342029,929511,343968,233132,643992,292853,265174,658782,63086,696604,886480,565131,503694,643128,823516,196769,784500,65688,717176) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540628 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540628 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]