SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001533s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 245380 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 245380 [ RunTime:0.004870s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (329296,2663,723879,408699,1011147,126405,287392,935829,440705,66941,662182,590736,638835,678432,62604,550554,732522,506501,51355,662558,930458,618460,530102,334753,917204,367610,817576,961391,443427,476518,294400,695887,441035,357552,516218,518049,556598,715090,366305,339812,614364,648968,728437,529569,1041117,688743,396008,985452,554451,702684,75303,146037,164335,576277,124776,705653,461414,158756,136048,872851) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001841s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 245380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 245380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]