SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001302s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 688318 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 688318 [ RunTime:0.002333s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (346082,1016686,99895,136788,765197,147676,398611,330750,996260,336308,714473,846968,990548,96599,138394,282947,420973,81938,739690,771065,473902,393976,531343,993076,879267,914679,1007933,36545,211116,428517,82484,196313,361624,865264,602867,382019,988017,855686,547323,384662,269315,1029562,811779,616441,743180,941104,523105,247626,860610,968329,229427,869951,1044216,658084,864857,144249,60407,352889,508061,439787) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 688318 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 688318 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001955s ]