SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 881443 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 881443 [ RunTime:0.003383s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (200570,840992,192997,147017,42732,943550,843763,817529,941038,242937,411949,308337,440294,202741,884030,551739,363371,481332,832059,738369,513517,371019,487539,578029,359769,547868,208162,330381,120073,745550,741243,840202,466331,746311,654517,1021597,263701,448582,485340,103558,745362,358427,244349,761129,117303,836593,571522,247387,762610,1021816,99939,380974,71922,764622,692413,710258,843318,521374,92106,37395) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 881443 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 881443 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]