SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001322s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341980 LIMIT 1 [ RunTime:0.000423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341980 [ RunTime:0.001849s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (879353,834889,600734,116732,275083,105046,491247,529430,167165,389023,182450,563467,253682,378299,967165,76210,733129,777365,315560,641229,52729,1030103,988409,817156,1005838,399495,357988,132292,879926,961573,49983,795270,383021,523627,312678,194993,595101,556005,420859,217824,498704,77908,215279,681474,69295,557755,266154,453529,744354,913947,666377,521617,108020,193077,538807,780780,863849,719924,733458,814557) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341980 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341980 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000715s ]