SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 489864 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 489864 [ RunTime:0.001730s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (192342,101979,461996,850775,603663,151999,123396,827906,282252,623790,381583,379845,1013120,566330,21442,380622,471409,892675,520655,919001,896285,712425,775207,975928,576636,106841,844457,118146,133233,70351,104653,712895,64227,648362,354059,816282,708628,373092,758606,331088,100453,533800,15261,69801,156973,123482,217442,1036081,548328,722500,833312,591154,883262,1036654,582900,977856,973151,566382,929966,461894) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 489864 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 489864 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004521s ]