SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001908s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 917104 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 917104 [ RunTime:0.002541s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (492875,922508,739835,401522,796083,455416,550205,942191,957667,808647,716826,187200,467336,951412,695483,100066,695912,886200,585017,303499,777114,929070,838384,434980,670032,1034675,599095,280580,769284,330047,629826,91762,939642,189124,324328,622359,575894,358339,459389,523480,251667,271181,623192,1033383,294618,672428,427429,214336,678169,11032,80087,702460,345991,785532,598770,591545,863196,591874,843418,939678) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 917104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000617s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 917104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]