SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405289 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405289 [ RunTime:0.004362s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (805127,656652,81200,105376,970100,582750,675824,657316,443492,172013,153342,213989,267312,936843,63924,196650,465329,973656,289650,937383,846156,496534,988360,855470,741059,106490,704431,554443,291776,921786,349867,411256,744514,44942,154500,651503,318911,755613,973146,856537,27738,80106,55318,212350,150629,463551,500366,856314,357037,699060,741713,914649,874809,782943,806512,740985,230625,447725,604820,282382) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002881s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405289 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405289 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002312s ]