SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 347416 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 347416 [ RunTime:0.002049s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (293303,981377,757019,353182,590095,184342,334680,590387,902501,681495,354770,751694,972225,899983,510386,810147,842757,860858,636597,594336,835168,129249,575891,677550,421000,392469,157032,472717,787987,599607,1037206,878079,666902,348892,685118,486572,120547,490988,823583,813390,132302,904276,77835,456207,379446,146712,873555,626447,287932,335726,344239,141829,887213,415319,236495,1008291,536711,742662,550123,501568) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 347416 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 347416 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]