SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001500s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 568104 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 568104 [ RunTime:0.002387s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (141050,103477,39461,5155,509117,727224,665768,724576,113253,71316,695340,959992,994763,842671,1020049,6059,870014,114040,820373,289551,241901,162501,284609,438934,701257,115442,436763,659597,632406,37669,844697,191054,920761,592684,731211,467373,924101,170903,958080,376194,792522,897615,151890,294558,91468,654678,715337,860844,894146,131598,511626,829236,423248,241008,946380,816031,65228,814913,755314,438908) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 568104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 568104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]