SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001325s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 308504 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 308504 [ RunTime:0.001692s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (414245,257228,456273,10295,192999,957679,10383,358799,125018,58425,369650,48773,367477,331355,492278,981145,532649,915157,644890,665964,469518,668465,15607,1009274,574521,109226,723707,956678,915975,22603,872828,604314,524140,54185,519449,453106,867649,118839,794701,210572,11749,986543,222158,211457,1000246,745234,547897,706314,857694,778011,198283,81881,717825,700868,245697,973162,718908,218171,961287,304891) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 308504 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 308504 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000667s ]