SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036891 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036891 [ RunTime:0.001698s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (434971,980366,455307,596549,701684,479379,214457,360808,387050,993134,751949,902271,960626,357077,938741,360827,65719,222246,147765,1005524,971275,37705,580593,191572,136109,821697,931522,598662,311352,912212,560846,451370,383114,851200,557226,746873,750879,1030569,227418,432349,1019390,112551,758467,293436,327022,567435,324779,136431,406506,900950,178109,644674,681720,13557,813471,105157,792826,403847,624733,522692) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001520s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036891 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000570s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036891 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]