SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414996 LIMIT 1 [ RunTime:0.000555s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414996 [ RunTime:0.002280s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (84704,1029772,146650,371142,950523,276756,989047,435247,917468,459451,162220,317046,327149,443212,953368,409831,10324,864580,147504,59162,351087,882485,371973,880141,976691,465155,656809,780842,80494,1026447,366950,1010246,221771,718790,230970,1025650,374240,400289,287584,270622,885612,694621,680705,926140,410662,165736,917835,441145,669159,448544,424033,862655,473351,423348,51118,278558,983848,85623,180591,556049) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414996 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414996 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001039s ]