SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001939s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291694 LIMIT 1 [ RunTime:0.001978s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291694 [ RunTime:0.003231s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (750716,100027,409784,122557,712733,526458,200002,360065,685958,884232,411928,853358,589022,25005,629423,796475,103301,10558,195919,210725,583715,439155,343174,218329,343974,1012839,412248,285956,688241,181560,221730,125021,92394,506515,362095,291131,545825,1036969,876426,507338,778556,150791,370924,851918,246864,349263,937085,527567,882106,915740,722964,199139,43887,74669,495816,612968,750067,772620,948628,173685) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291694 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003241s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291694 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001373s ]