SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 744482 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 744482 [ RunTime:0.002688s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (480527,41128,190768,422450,144949,569697,569447,392601,356943,597330,825915,192814,648747,1036238,28913,739127,1026688,540514,250196,829973,751251,113983,534639,798276,596828,689407,770971,82030,110249,551608,1020650,417528,328526,71195,910726,938982,520554,490750,890445,283808,53911,551635,1042723,230965,1025940,854780,1037496,717684,935167,231608,445945,931885,284048,573079,116407,993482,106397,530226,126739,899536) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001473s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 744482 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 744482 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000715s ]