SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 391090 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 391090 [ RunTime:0.001828s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (55786,535074,709465,1004791,330272,504097,547053,53079,92511,461194,541163,641705,105039,355312,507499,193616,178935,663573,337113,544895,674390,792885,822987,109915,611362,908046,770533,298053,576264,413028,301711,603954,365667,946782,607576,166999,193227,659961,799684,607525,775515,365091,238846,571886,711433,668660,338119,319733,953726,849098,165067,1018370,408215,44769,596480,668410,964845,557633,977643,874131) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001697s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 391090 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 391090 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]