SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001352s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 461893 LIMIT 1 [ RunTime:0.000431s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 461893 [ RunTime:0.001598s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (265854,71209,343033,957604,554859,458851,1803,456248,973423,830062,934665,829043,263041,938954,932921,429761,785919,1042995,1035399,372489,125689,106275,51449,416785,771744,513547,852246,204122,820177,543565,924240,156682,28695,449543,853981,228696,899907,836173,68028,277192,533511,399692,141131,867544,811101,846139,549003,660331,666604,684756,40760,297425,122151,830995,853420,182824,1032840,625055,531708,110534) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 461893 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 461893 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001351s ]