SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103141 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103141 [ RunTime:0.001441s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (809693,701154,84132,489969,423801,207205,128812,838212,730110,382531,113910,719315,675288,95596,477928,638299,899646,1011392,1024073,324707,327583,889731,496964,781615,761130,430977,116891,643680,785904,388576,798046,553571,477205,636330,776575,1031091,1020807,492320,288976,237689,501140,621894,629032,860004,979099,718815,615935,842297,939279,276936,667336,232324,562843,947506,399402,595547,260249,493917,763384,901101) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103141 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000551s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103141 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000645s ]