SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53366 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53366 [ RunTime:0.002055s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (790615,875235,957478,760427,373042,560546,1034990,820343,1031311,494084,145197,1000523,815394,814124,350511,77591,194752,143843,588843,676758,591251,906033,825874,233728,69776,1038633,444511,970963,429203,656810,855927,32903,440064,1022177,258767,768843,320306,679838,91489,187690,882277,102206,1018084,865258,653730,137370,902989,940762,276025,794612,640054,257703,526449,915395,294568,882225,557801,927862,118087,1027736) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53366 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53366 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000643s ]