SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001693s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 42410 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 42410 [ RunTime:0.001758s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (352864,513439,458806,560306,118030,997403,886017,704821,776946,1009112,943315,930245,414252,575331,458106,871013,713581,461259,376963,67727,286368,686869,145433,209641,821996,292176,761560,184567,453822,238049,622576,291007,524525,31875,665036,184474,679816,126853,852648,122282,340031,300928,788331,522766,950368,311604,237049,14509,392954,815345,304535,954524,119583,739321,687731,234570,678606,195287,529885,781572) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 42410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 42410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]