SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 552911 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 552911 [ RunTime:0.001554s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (592954,401723,525129,159098,230037,588278,427643,800266,205584,855965,545122,744164,1002023,400375,86071,767733,220452,527935,66959,929350,658256,981093,878880,267399,728934,24239,282522,495803,1046794,670801,9634,752296,81001,150185,697005,137624,374117,352571,179072,312315,476802,1043663,516581,862942,248276,1017653,750800,91452,427744,549725,440571,544569,846335,671246,901400,356736,7221,563621,953090,505923) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 552911 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 552911 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]