SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001704s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 431273 LIMIT 1 [ RunTime:0.000488s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 431273 [ RunTime:0.001600s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (796734,103141,520837,688880,705859,260511,109417,586683,340699,108767,505812,530777,858366,964819,1031302,234335,205985,807129,120120,1031361,340997,107159,360225,126502,1006517,750689,895382,1002284,99857,615380,641099,560592,663306,277401,794024,491513,897808,31672,763189,853657,128992,526559,437946,291924,558536,404162,857482,814677,208993,410331,151983,311617,1024961,547344,960382,236185,935775,827300,213378,445143) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 431273 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000641s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 431273 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000642s ]