SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046110 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046110 [ RunTime:0.001930s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (519539,311990,506588,280945,209835,877678,973483,386643,281013,832587,153102,683265,960561,201829,650344,499255,214130,961560,99113,193198,33197,521479,138014,577334,447753,916812,759134,258057,64566,996890,847457,237133,560,32707,412409,589288,115269,250456,166039,386139,307147,338401,273233,160487,205977,237574,9921,896776,658720,700431,21836,736166,269636,588586,669354,233844,441483,324415,30411,956473) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046110 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046110 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]