SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001395s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40798 LIMIT 1 [ RunTime:0.003500s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40798 [ RunTime:0.003021s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (732648,1039220,387889,69046,232277,472923,467748,476664,1019082,415549,856900,196696,32791,489667,427632,957884,924054,733248,515007,815636,428075,688314,344890,183230,509107,252354,925703,51421,812260,540973,638717,1003833,1042605,406592,364557,1032105,286567,341477,513276,1020010,674386,974272,143293,362814,269017,130313,299179,379900,422353,983575,876521,972370,120827,61903,713569,423744,205130,437329,353646,706571) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006529s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40798 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001660s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40798 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]