SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5289 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5289 [ RunTime:0.010184s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (685296,1045941,661374,206161,400723,98879,59221,790745,158001,2549,240744,754132,150050,921191,650078,196714,875538,31469,157131,151526,815213,576483,989560,619311,166553,949848,7526,544890,931079,956843,744480,856252,561379,836362,932538,563692,899948,533189,33327,980263,483166,2007,500536,929775,556654,161287,116762,202010,669433,799559,897802,813973,404982,1039772,270164,93990,914443,733833,937427,328583) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5289 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000466s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5289 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]