SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414004 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414004 [ RunTime:0.003604s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (664750,34559,87203,1029783,846078,112481,605673,202544,756050,271255,251906,285604,291077,165266,361260,438175,824499,473838,813250,220105,118653,403194,78064,680108,765125,174794,376762,998497,382669,90940,372882,847705,789584,726033,1042688,250848,641196,496830,1028369,270745,747910,486595,518369,270354,358673,340632,134192,730401,750734,583939,433885,261773,854438,501823,599022,11974,842727,344417,606986,112929) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001020s ]