SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 440524 LIMIT 1 [ RunTime:0.001377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 440524 [ RunTime:0.006727s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (332845,585113,377871,639131,503493,26089,180529,653864,33417,575553,904826,253025,795696,970204,3005,183845,682323,713103,479864,287272,283161,292337,679746,269352,996473,11366,95557,455902,241339,1009073,943035,187731,198772,998019,568119,865788,926241,88179,324762,935681,406158,238750,185607,754745,920924,320358,533507,1019180,1006553,862074,242812,294488,674948,695515,977143,796094,238244,856585,788526,57849) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.024209s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 440524 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000595s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 440524 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001265s ]