SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005796s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 485401 LIMIT 1 [ RunTime:0.003926s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 485401 [ RunTime:0.009106s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (622890,97228,452307,366735,672342,910681,581655,679815,337473,785676,939699,753622,1045667,991842,443787,52272,877352,191257,674194,403262,404934,459067,375591,938706,960992,320178,15037,33175,691139,870576,882728,502164,740266,428487,808986,25305,73687,1042775,757980,246256,961645,712882,422900,699978,935457,734264,392709,857238,281600,816505,477170,722023,270871,451773,381304,764706,861790,985392,398391,31219) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005692s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 485401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004504s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 485401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003505s ]