SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 49105 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 49105 [ RunTime:0.001592s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (520273,698191,472976,973459,290601,204021,522383,273563,758738,61291,124979,836192,371280,510866,312428,731806,795991,568640,735305,88541,440192,555545,419239,634994,784785,707857,943123,758763,250717,37565,105647,579608,798140,172609,654142,285092,692766,482660,956056,362679,203714,389779,565302,132230,905940,920206,967789,76944,890928,1001971,986023,47311,905942,909440,670171,740948,446733,557124,682907,421684) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000964s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 49105 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 49105 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000390s ]