SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416105 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416105 [ RunTime:0.001626s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (638815,653225,928140,952928,666242,688976,157340,608031,951020,679067,948864,360504,1011775,526686,958278,338999,638264,218030,314533,333488,1030869,525071,59130,462071,471057,159920,800135,373256,827240,652092,431688,837057,324673,898713,275851,812610,164674,108719,541946,981967,540199,283450,802505,461647,987034,651700,537590,682386,544551,536448,298770,621750,868370,964134,1022883,669326,1024576,1045892,21608,352168) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416105 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416105 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]