SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001300s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 378302 LIMIT 1 [ RunTime:0.000480s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 378302 [ RunTime:0.002712s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (324028,617932,240586,556617,564643,918832,840973,910465,264246,628977,198660,613102,52912,39359,954498,71355,47346,94385,549107,934163,832402,75921,911525,141708,486658,538797,401404,625759,591058,66297,192624,828669,1042721,998974,923412,191805,975859,918629,427722,560107,801580,1004084,932663,322695,294044,873757,559921,26027,927525,906710,852966,115997,404289,832463,145476,643428,804322,904343,278769,836889) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 378302 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000685s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 378302 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000704s ]