SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 222161 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 222161 [ RunTime:0.001918s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (141929,888532,29614,185445,856843,1030614,297303,1010616,393812,20044,246808,390451,324666,841000,38922,789281,132023,502403,421682,269690,104587,114252,331814,1005585,919057,433685,186854,827066,877054,595432,48830,974335,499950,433270,829160,798114,842877,134182,175065,886396,579035,187783,1034630,615024,545335,417822,786401,243733,456340,340915,401828,181090,16726,960126,984403,504247,497577,53867,963037,169806) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 222161 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 222161 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]