SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 991553 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 991553 [ RunTime:0.001674s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (548599,949240,639858,197601,979153,105971,656599,561173,468143,385230,745218,429741,986299,824459,479213,795615,1042619,550533,848548,54988,509355,801140,317954,692111,348474,539102,114771,1046471,932534,750158,955136,715132,991072,176213,55263,404548,980300,413107,590973,604401,463650,969216,255006,982905,979684,238382,549769,380871,163581,90109,305354,871878,320918,492389,397271,33712,896368,781463,724399,601066) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 991553 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 991553 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000460s ]