SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509771 LIMIT 1 [ RunTime:0.000537s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509771 [ RunTime:0.002693s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1042648,75720,585796,571092,364537,775134,986591,230761,866663,23044,978991,243532,1018886,984724,726597,123694,26596,829230,697527,314061,369064,262191,406295,1024331,904847,1034904,239423,405785,531127,534269,859741,178380,892610,181633,340611,187435,845680,70584,1015232,1041342,255132,122239,265026,796334,102280,924733,160971,353263,223871,458110,852697,493941,809012,862326,180789,116861,217202,913599,333343,73333) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.017986s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509771 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000599s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509771 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002870s ]