SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046938 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046938 [ RunTime:0.002466s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (378336,894063,577113,286134,196574,150071,882655,75859,654044,1018796,155465,182225,359767,557501,1045873,543669,473897,712488,315847,936530,213684,467608,859907,868876,267305,921752,444861,76607,508838,499377,191928,672425,691143,705923,614196,470223,648924,646323,106605,620798,512856,430057,472169,34501,376685,924502,920110,92990,396196,1017352,813241,971673,752370,815090,837761,806853,846034,892155,289629,958659) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000956s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046938 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000317s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046938 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]