SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 448027 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 448027 [ RunTime:0.001746s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (317277,958518,112623,84921,564052,208200,391031,154615,152547,263410,1921,996552,211189,730542,258581,2051,228244,703311,346053,346653,454123,237171,99373,687278,22907,625624,178777,127124,563568,1011978,91904,401867,385994,398620,1000413,823195,304769,177912,687598,61410,241626,192708,569773,459353,624826,322249,1002013,1035953,839310,71016,515348,169041,103716,139998,1517,507042,495924,1010320,611623,266852) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 448027 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 448027 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]