SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001376s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10141 LIMIT 1 [ RunTime:0.000618s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10141 [ RunTime:0.002320s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (426402,732336,625038,408975,407979,692591,764201,896677,602794,74463,476143,619595,456998,373642,888342,666531,858807,541248,301603,512732,395256,722830,42231,78756,161450,468376,405751,41766,447455,854934,227546,494401,164698,987936,430513,8904,647967,581250,629638,609106,327202,1006497,679324,172107,275276,233138,89900,142256,620993,401083,615176,912951,71280,320960,986097,1009721,220678,632874,526230,353759) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003850s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10141 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000529s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10141 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000776s ]