SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004110s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 558080 LIMIT 1 [ RunTime:0.001684s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 558080 [ RunTime:0.006196s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (174246,811546,1044122,358623,803728,892238,404094,101765,359703,470773,644262,277901,366715,127283,547727,720249,520857,87728,847875,337631,261059,202162,320911,125208,155393,758514,729598,393045,604732,31090,98959,1048787,167719,537021,461755,301205,810222,375203,871630,449136,182981,768780,451244,472461,507335,150688,18474,519572,28456,587523,1036527,131735,514955,309615,288072,841369,241856,340281,944886,530570) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002692s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 558080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 558080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000913s ]