SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414893 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414893 [ RunTime:0.001691s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (115692,345487,545982,692402,319130,838871,287919,102559,388844,59204,345468,186824,462986,884078,1039606,426207,269187,469915,420092,930339,802978,681838,291022,202549,20584,207581,996693,43294,626252,204765,673622,849585,357141,631015,781233,65601,305664,89134,902675,905777,808275,722913,553470,278718,281458,433189,419950,527084,58285,869032,36465,94826,705801,969028,992732,79442,53463,950092,757686,915241) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414893 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414893 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]