SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420141 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420141 [ RunTime:0.001890s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1034487,871227,767114,190846,23260,646096,140187,565798,820166,566933,472841,280606,386287,327574,759479,360483,511961,69593,237098,1010639,53172,890246,410680,74742,33604,321333,924937,958547,651739,69778,179479,371369,916939,838219,908034,630776,828505,816655,482429,869379,1022801,339026,36639,217170,460830,300428,740422,546294,123898,947773,32986,130939,749308,72591,132154,15300,843996,182694,633682,133281) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420141 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420141 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001012s ]