SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427876 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427876 [ RunTime:0.001878s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (240562,598218,711498,498551,130342,407502,1032916,397292,109076,781884,228137,413941,446471,995515,659946,777163,747105,461274,285409,571516,708134,120590,4291,662015,87838,857634,31101,418170,839159,330909,938207,600087,1032886,515135,841951,110603,574076,541969,195200,717304,374633,807813,488465,1040885,716749,788417,425019,471127,421539,303254,399593,223736,906698,266939,397691,137600,241212,804124,619582,922275) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000872s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427876 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000772s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427876 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000408s ]