SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018567 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018567 [ RunTime:0.001490s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (82102,5663,704908,268820,586648,684982,30307,253836,929210,511524,910050,984707,652016,417687,388450,299892,175393,618255,796812,320624,555318,645502,356768,399350,237448,977746,71585,780754,307440,261117,143326,631620,407646,943868,494613,23476,1027371,365723,725586,682940,807844,614760,161142,928772,403205,584689,1037420,857761,330732,175155,563041,798221,882252,55020,8940,1025125,464340,357137,443471,1021723) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001596s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018567 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018567 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]