SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043122 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043122 [ RunTime:0.001577s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (666982,40649,812294,701597,520968,729361,1031599,276069,618390,44728,637926,313744,198763,979080,1017634,788246,1671,497974,882857,17696,525508,317543,54400,810759,931427,596068,282546,616635,151119,962338,299926,257735,485339,435291,359865,12866,949895,1010735,884557,992959,810814,623405,297358,19134,145071,325141,944310,545495,981963,1004440,310983,409605,567322,985664,852390,537034,792066,10831,481846,149190) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043122 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000521s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043122 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]