SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407005 LIMIT 1 [ RunTime:0.000703s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407005 [ RunTime:0.001698s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1047012,445406,471532,726151,276005,893060,787810,702533,64081,815381,175600,101455,900618,222987,272892,990071,950970,50723,285678,484556,852729,72204,921804,330570,190812,35114,774583,449335,528230,503958,304648,291614,605070,347637,78568,162639,874009,744496,545282,352556,176430,6013,837167,485845,497305,60964,938663,365582,870985,215329,580596,53224,10234,434328,1003944,447927,923547,952608,296498,342532) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003651s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407005 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407005 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]