SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 90528 LIMIT 1 [ RunTime:0.000427s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 90528 [ RunTime:0.001854s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (294897,1012842,441048,217626,616324,227618,658902,1032979,338859,90902,948029,259364,851551,778178,181795,887562,390003,503465,135599,229938,551791,203640,317049,474150,206203,816333,47881,47244,258626,901886,921628,770935,1042724,511205,967405,1042938,793254,486222,155412,157270,644172,211723,689530,448349,791732,589793,702650,218605,716717,465703,256886,443949,952567,272263,852444,807556,794643,692791,958408,259770) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 90528 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 90528 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000446s ]