SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 269640 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 269640 [ RunTime:0.001573s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (876864,34654,336755,804458,900091,181330,379229,184391,119308,460719,86408,738708,730178,87280,796987,261571,547318,96661,158230,746584,187788,115944,159020,236776,487702,461955,970598,438317,336412,464495,712158,400235,473421,324948,960069,292325,174102,551203,343515,783390,726811,418656,197177,359684,394511,574775,834091,142998,610929,142046,859187,15645,1042232,156568,683175,259192,437968,69719,493510,119040) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000926s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 269640 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 269640 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]