SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 491791 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 491791 [ RunTime:0.002096s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (429290,887669,567018,454936,326466,111258,627734,957222,71954,49646,413539,25256,126636,832030,418162,178371,49958,462705,1028568,630939,372441,305263,16761,951093,137170,5342,51676,880255,285395,397745,94943,316231,347646,488508,1004971,855290,284619,413986,507918,869625,799285,121025,417002,205619,419229,128129,367459,1006530,1002356,697708,523050,74069,997816,991039,117632,167212,6411,133608,69710) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 491791 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000586s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 491791 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]