SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104561 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104561 [ RunTime:0.002954s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (326253,1034401,849141,102989,836495,807150,776059,767401,727215,94813,699440,341599,97683,81449,157243,118791,1028811,34171,963132,489034,141918,545192,215747,357845,76981,599995,335364,171191,824126,64425,260374,20467,854718,14825,451857,292690,925526,488938,186831,667129,174551,447888,839292,754098,750169,955128,517802,404597,692859,699647,385077,140093,221584,434722,138825,282621,1018388,548662,97952,219928) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104561 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104561 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001062s ]