SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001360s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498550 LIMIT 1 [ RunTime:0.001096s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498550 [ RunTime:0.002594s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (394896,714975,482119,316750,157221,459407,18544,965871,263524,510373,1032422,811155,621836,230909,180379,821299,803718,200182,590904,768797,582835,283467,543693,499891,918311,737898,441929,426013,870042,80436,93306,289893,91245,453280,383765,974383,821347,702104,120169,918141,628351,782517,666952,694553,356865,14475,123064,616000,138928,1012531,720167,1002134,668403,760905,605154,295317,520451,444633,557465,238491) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.019385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498550 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498550 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002254s ]