SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001462s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101671 LIMIT 1 [ RunTime:0.000473s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101671 [ RunTime:0.003261s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (329866,730063,828169,1017520,332188,36039,151051,894942,559536,57397,11559,878796,1012361,63657,117397,7008,813550,24895,747850,408093,570548,804348,386263,619831,75074,882439,253714,394237,928274,660394,178925,924973,164977,740953,984842,981466,61334,603472,255310,234261,523523,424083,592967,515624,932184,426210,151972,203134,867670,771536,952697,624691,952271,143677,258550,880244,269592,192883,107237,668925) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101671 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101671 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000633s ]