SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000944s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413150 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413150 [ RunTime:0.003001s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (459101,124432,694035,388293,679091,742595,460092,893934,885711,805377,718283,901384,527282,1015947,556311,346444,450977,989057,142717,898294,795179,200068,61748,525607,619599,221444,513249,626993,706688,891078,370827,597904,364894,952965,648026,798126,736460,91649,819534,701964,677085,983041,402974,681860,710736,322998,328503,333614,723627,719343,855567,783973,952524,402555,41131,80399,197879,861614,1009235,764030) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413150 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413150 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001617s ]