SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 442220 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 442220 [ RunTime:0.006182s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (41800,278941,325621,705854,56812,117172,621230,1005353,457408,254673,316328,1043218,544809,882274,363703,628575,235649,598795,173679,482767,126557,456499,836511,966752,235609,666871,609028,45421,954620,665812,644719,749206,931883,298412,417135,835875,1001397,337811,843146,696821,76433,881670,212025,213170,635039,401364,235523,777686,670937,418279,411133,468013,7572,305863,98031,532777,385754,847916,237987,348451) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001586s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 442220 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000455s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 442220 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]