SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001423s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 362523 LIMIT 1 [ RunTime:0.001126s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 362523 [ RunTime:0.002032s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (514365,1001008,740291,235582,42531,781701,362580,746821,137998,180204,357537,563746,877356,636345,742983,10265,21665,213591,277186,956384,12034,136882,864168,512301,500315,910273,294025,955270,760044,201628,195450,463004,420266,8166,593242,658690,818066,376965,821499,593542,473146,646588,554368,1007217,44996,624225,907652,838513,166703,319113,463293,567506,753357,454920,696225,812540,339169,540844,79691,257756) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 362523 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 362523 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]