SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802660 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802660 [ RunTime:0.001834s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (226347,742091,263047,330391,284635,351138,1037367,886742,20177,156925,96530,544331,832328,981382,484309,476407,326289,208219,635470,575246,998497,175310,719649,497219,465605,455103,749388,860393,292528,449507,661192,63493,967890,576200,653365,921199,476804,519840,339965,659713,770438,188943,27167,296779,409896,123986,487383,128034,171491,16337,898629,130789,679760,523836,595474,483652,512893,381822,234177,196063) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000967s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802660 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802660 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000451s ]