SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002773s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047252 LIMIT 1 [ RunTime:0.000464s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047252 [ RunTime:0.001805s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (732215,147229,1034847,370912,143329,344736,559740,145648,300769,591876,135811,467523,943371,799372,238140,602074,113540,1043522,635122,188640,995746,798013,171226,499651,724955,773532,854410,494727,225604,66215,423154,603463,539117,692660,511892,273831,228373,978922,646745,2866,57723,877557,716616,874932,63715,564006,185384,527308,138522,742037,782294,523506,763098,629013,440586,820339,489652,410724,79185,163871) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047252 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047252 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000846s ]