SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002276s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039215 LIMIT 1 [ RunTime:0.005605s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039215 [ RunTime:0.008103s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (403734,15423,410758,394812,613336,562804,262368,928690,971974,254946,312948,438486,985476,1014903,315596,668947,659960,49334,521259,453909,399182,457351,388133,708881,677097,368217,156411,842295,88830,307536,754363,399684,859996,547233,2236,751524,318154,272860,36610,307,776169,538011,645702,995610,590410,873171,783586,309147,215763,262778,663037,377081,912192,12051,10780,391216,203013,129254,1048317,473901) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002885s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039215 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000631s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039215 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000427s ]