SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400161 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400161 [ RunTime:0.001690s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (441799,676192,312234,371679,871825,995995,486916,997048,245012,591854,120098,216401,1012864,902524,19977,975729,955946,99704,977899,707264,562791,124994,25810,666440,20222,894724,204453,165983,1023722,756901,233243,630182,1008126,884140,724133,529104,844048,715450,266072,710391,611,711702,768817,347040,297660,460567,170103,99678,719263,246355,166443,834453,1043404,908090,704222,89547,172326,604356,821693,467463) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005742s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400161 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000508s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400161 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]