SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002983s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043524 LIMIT 1 [ RunTime:0.000633s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043524 [ RunTime:0.003969s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (44340,337244,634392,65771,173910,166788,246524,196764,58554,240317,833563,960307,1026128,356743,118814,692097,783528,293942,355542,273438,269072,1018138,412240,741979,147333,220575,443319,158453,690787,1017933,887147,613103,455010,456657,24594,466833,238357,596434,606072,616373,102194,899155,763189,517107,957233,731196,66495,337013,920851,517775,1022360,466251,872370,996567,280109,44603,301802,797189,458026,944940) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043524 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043524 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000829s ]