SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 72210 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 72210 [ RunTime:0.003128s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (582798,648601,1046214,36698,466815,822915,612674,710717,153647,579033,128122,680041,305475,634267,731041,997290,106133,1042092,25123,555896,427044,69988,305409,248543,678128,729872,624830,1027537,322941,223299,124368,197594,315070,445902,771219,489447,1012437,269502,171721,206185,634812,97964,698466,1048189,838712,317286,896548,317206,588135,314266,13288,53941,1040931,888518,1011002,117027,812297,546772,383508,607395) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 72210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 72210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]