SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102841 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102841 [ RunTime:0.001578s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (790107,983259,724080,766150,658055,23077,142244,941651,721204,994885,907445,552101,803159,824467,159906,930464,866955,1002783,645876,300337,839522,703465,324914,217138,976431,17291,82799,813110,327948,941358,912848,5305,259645,133395,672870,614528,159401,855509,163561,854749,822460,91225,772860,192547,197156,654796,916512,331670,131177,621355,182335,1028654,161871,76745,521590,746380,192697,615913,671483,733533) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102841 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102841 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000423s ]